package com.pro.dao;
import com.pro.entity.UserFeedback;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * auther 杨沛琪
 * createDate 2021/11/8
 */
@Mapper
public interface UserFeedbackMapper {
    //获取用户反馈列表.
    public List<UserFeedback> getTable(@Param("page") Integer page, @Param("limit") Integer limit, @Param("gid") Integer gid);
    public int getCounts(@Param("gid") Integer gid);
    //查询反馈
    public List<UserFeedback> queryFeedback(@Param("userId") Integer userId,@Param("feedbackType") Integer feedbackType,@Param("feedbackClassification") Integer feedbackClassification,@Param("createDate") String createDate);
    //待审核
    public List<UserFeedback> queryToBeReviewed(@Param("feedbackStatus")Integer feedbackStatus);
    //查询待审核个数
    public Integer getToBeReviewedNum();
    //查询已受理
    public List<UserFeedback> queryAccepted(@Param("feedbackStatus")Integer feedbackStatus);
    //查询已受理个数
    public Integer getAcceptedNum();
    //修改已受理111
    public boolean updateAccepted(@Param("feedbackId")Integer feedbackId);
    //删除
    public boolean del(@Param("feedbackId")Integer feedbackId);
}
